{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Design Flows","Coeff","Map","Sheet1","NOAA Data2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,0,52,16383],[19,0,19,16383],[6,0,6,16383],[1,0,1,16383],[32,0,32,16383],[43,0,43,16383],[50,0,50,16383],[18,0,18,16383],[38,0,38,16383],[39,0,39,16383],[40,0,40,16383],[41,0,41,16383],[42,0,42,16383]]}
["Refer to the current drainage manual for a more detailed discussion of the methods and equations used.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v14a"]
[]
[null,"So",null,"Cells on the lines below this color or immediately to the right require user entries.  Project identification cells above this line need to be populated."]
[null,8,null,"Cells with this color denote that the total travel time in the ditch segment was changed to 8 minutes if the calculated time was < 8 minutes."]
[null,"n",null,"The value(s) below this cell is required if a user roughness is entered (see below); otherwise it is optional."]
[null,1.89,null,"Cells colored in this manner denote that the calculated shear exceeds the allowable shear (user roughness options only)."]
[]
["Storm design intensities are calculated based on NOAA data (NOAA Atlas 14, Volume 2, Version 3.0).  Backward compatability with Thiessen polygon intensities is provided."]
["The appropriate Thiessen zone may be selected from a pull-down box in cell D7. Each zone is shown on the state map shown on the worksheet, \"Map\"."]
["The NOAA design intensity option may be selected from the drop-down box in cell D7.  Current latitude / longitude are displayed based on the current values in the spreadsheet"]
["Retrieving and using NOAA intensities requires that the macro be run twice.  The first time is needed for the user to copy NOAA data from the NOAA website to spreadsheet \"NOAA Data2\"."]
["The second run is needed to run perform the calculations using the retrieved information."]
["When the program is run, the user will be asked if he wishes to locate the site if cell G11 = \"Yes\".  If the answer is \"No\", the intensities that populate the NOAA2 spreadsheet will be used."]
["If the answer is \"Yes\", Internet Explorer will display a map from the NOAA webpage from which the user copies and pastes the NOAA intensities.  When the NOAA webpage is "]
["displayed, the default data is \"Precipitation Depth\"\".  Change this option to \"Precipitation Intensity\".  Move the small \"X\" under the red cursor to the site and zoom in until the site is located."]
["The NOAA data is displayed below the map.  Copy the interior part of the table from \"5-min\" to the last cell entry for 60-day in the lower right to cells A4 to K41 on sheet \"NOAA Data2\"."]
["Copy the site identification data including latitude and longitude to cell M1 on the \"NOAA Data2\" sheet, as shown."]
["To use the newly copied NOAA values, simply rerun the macro and answer \"No\" to the previous question about locating the site."]
["Once NOAA data has been placed into the spreadsheet, the user should change cell G11 to \"No\"."]
[]
["It is not necessary to enter a specific value for normal depth, dn or roughness.  The macro assumes initial values.  User values for roughness may be entered by preceding the value"]
["with a specific lower case letter as described below.  Specific upper case letters tell the program to solve for roughness using a specified liner type."]
["When user values for n are entered, actual and allowable shears are calculated.  Actual shear is color flagged if greater than allowable shear.  User roughness options are:"]
["  g.xxx - represents an undeveloped option for Gabion mattress"]
["  r.042 - represents a Class II channel lining with roughness = 0.042."]
["  s.045 - represents a Class III channel lining with roughness = 0.045."]
["  t.039 - represents a TRM, type 1 lining as a vegetative Class C grass with roughness = 0.039 and allowable shear = 6 psf."]
["  u.1.5 - represents a rock lined ditch with D50 = 1.5 feet."]
["  v.039 - represents a Vegetative Class C roughness value = 0.039.  Allowable shear = 1 psf."]
["  R.042 - represents a Class II channel lining that uses a program calculated roughness."]
["  S.045 - represents a Class III channel lining that uses a program calculated roughness."]
["There are no options for G,T,U and V.  When user roughness options are NOT entered, the program will select a liner that satisties hydraulic flow equations and meets shear requirements."]
[]
["User and program selected n values are applied to all design storm return intervals.  Up to 3 channel segments per storm may be entered."]
["The first channel segment contains the drainage area for sheet flow, shallow concentrated flow and the first channel segment."]
["Overland flow, shallow concentrated flow and concentrated channel flow segments calculations may be omitted from the calculations by zeroing out the input data."]
["KYTC's practice has been to include shallow concentrated flow as part of channel flow."]
["The 500 year flow is calculated as Q100 * 1.2."]
[]
["The IDF curve fitting method employed in FHWA's Hydraulic Toolbox 3.0 is included.  The exact same coefficients and design storm intensities are obtained if the same NOAA intensity data is used."]
["A summary of the coefficients used for each design storm is shown beginning in cell A21.  A comparision of calculated intensities using the design equations to the intensities shown in the NOAA"]
["table for select travel times is shown beginning in cell 45.  The color codes reflect the closeness of agreement of the calculated intensity results to the NOAA data.  The color scheme uses green as"]
["close agreement (maximum difference of 0.03), yellow as reasonably close agreement (> 0.03 but < 0.1) and red as large disagreement (> 0.1)."]
[]
["An option to display additional output columns for each stream segment is available in cell \"U3\".  Enter 0, 2, 5 or 14 before running the macro."]
["  \"0\" displays no additional columns in addition to the 7 usual columns."]
["  \"2\" displays 2 additional columns for normal stream depth and roughness in addition to the 7 usual columns."]
["  \"5\" displays 3 additional columns for stream velocity, Reynolds number and method in addition to the 7 usual columns and 2 additional columns.."]
["  \"14\" displays 9 additional columns for calculated shear, permissible shear, safety factor (rock), Shields' parameter, Reynolds no., delta (rock), cross sectional area,"]
["         required liner, required D50 and D50 used in analysis in addition to the 7 usual columns and 5 additional columns."]
[]
["Press CTRL-r to execute the macro."]
[]
["NOTE:  As the side slope approaches the angle of repose, the Reynolds' number may increase rapidly."]
["     Gabion mattress, Type 1A usually will not be selected as a liner solution because Class III liner calculates to be stronger than a mattress unit based on a current HEC design method."]

{"sheet":"Design Flows","index":1,"n_rows":102,"n_cols":49,"rows_kept":102,"cut":false,"hidden":false,"merged":[[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[6,3,6,4],[6,5,6,10],[7,2,7,16],[10,4,10,5],[10,7,10,11],[10,2,10,3],[9,2,9,3],[4,13,4,16],[5,13,5,16],[12,7,12,13],[5,0,5,2],[4,0,4,2],[6,0,6,2],[5,11,5,12],[4,3,4,10],[5,3,5,10],[4,11,4,12],[9,6,9,7],[9,10,9,11],[6,11,6,12],[8,0,8,3],[12,0,12,6],[6,13,6,16],[1,0,1,4],[2,0,2,4],[3,0,3,1],[1,18,1,19],[3,13,3,16],[1,14,1,16],[3,11,3,12],[1,5,2,13],[3,2,3,10],[2,18,2,19],[3,18,3,19],[2,14,2,16],[7,0,7,1],[8,12,8,16],[8,4,8,11],[9,8,9,9],[9,4,9,5],[11,0,11,16],[12,14,13,16],[13,12,13,13],[18,5,18,11],[16,12,16,13],[14,14,14,16],[15,14,15,16],[16,14,16,16],[14,12,14,13],[15,12,15,13],[18,12,18,16],[18,1,18,3],[56,0,58,0],[44,0,46,0],[47,0,49,0],[50,0,52,0],[53,0,55,0],[42,1,42,6],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[43,7,43,8],[58,7,58,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8]]}
[]
["Kentucky Transportation Cabinet",null,null,null,null,"RATIONAL FLOW ANALYSIS and DESIGN",null,null,null,null,null,null,null,null,"TC 61-507C",null,null,null,"Output"]
["Division of Highway Design 04-13",null,null,null,null,null,null,null,null,null,null,null,null,null,"page 1 of 1",null,null,"v16b","Columns:",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V=",{"$f":"O21","v":1.8349641743641687},"D50=",{"$f":"Y21","v":0},null,"dn",{"$f":"M21","v":1.3432497546527264},null,"Fr=",{"$f":"AO3/SQRT(32.2*AT3)","v":0.27901096343861914}]
["County:",null,"Any County Name",null,null,null,null,null,null,null,null,"Road Name:",null,"Any Road Name",null,null,null,null,"(0, 2, 5,14)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T=",{"$f":"B15+AT3*(A15+C15)","v":9.0594985279163591},null,"num",{"$f":"0.262*AT3^(1/6)","v":0.27520780910280301}]
["Federal Proj. No.:",null,null,"Any Federal Project",null,null,null,null,null,null,null,"Route No.:",null,"Any Route No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b=",{"$f":"1.14*(AQ3/AQ4)^0.453*(AT3/AQ3)^0.814","v":{"$error":"#DIV/0!"}},null,"dem",{"$f":"2.25+5.23*LOG(AT3/1)","v":2.9202599066605588}]
["State Proj. No.:",null,null,"Any State Project",null,null,null,null,null,null,null,"Item No.:",null,"Any Item No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blodg","n",{"$f":"AT4/AT5","v":9.4240861395626541E-2}]
["Intensity Region:",null,null,"NOAA",null,null,null,null,null,null,null,"Station No.:",null,"Any Station"]
["Comments:",null,"Any comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dn/D50=",{"$f":"AT3/AQ3","v":{"$error":"#DIV/0!"}}]
["Overland Sheet Flow",null,null,null,"Geographic Site Location",null,null,null,null,null,null,null,"Shallow Concentrated Flow"]
["Lo","no","So",null,"latitude:",null,37.509799999999998,null,"longitude:",null,-86.325100000000006,null,"k","Sc","Ls","Vs","tsc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bath","num",{"$f":"1.49*AT3^(1/6)","v":1.5651131128365512}]
[60,0.24,0.125,null,"Locate Site:",null,"Yes","Leitchfield, Kentucky, US*",null,null,null,null,7.5999999999999998E-2,0.02,100,0.35253515682836511,4.7276608712194292,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(Fr)",{"$f":"(0.28*AW3/AQ5)^LOG(0.755/AQ5)","v":{"$error":"#DIV/0!"}}]
[]
["Channel Flow Segments",null,null,null,null,null,null,"Q10 Storm Results",null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(REG)",{"$f":"13.434*(AQ4/AQ3)^0.492*AQ5^(1.025*(AQ4/AQ3)^0.118)","v":{"$error":"#DIV/0!"}}]
["LSS","W","RSS","L","Sl","Ar","C","dn","n","R","Shear","Q","Liner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f(CG)",{"$f":"(AQ4/AT3)^-AQ5","v":{"$error":"#DIV/0!"}}]
[3,1,3,600,0.01,9.14,0.4,1.48541475089499,6.2330537327072388E-2,0.77971208480092769,0.92689880455847373,16.368755116909,"Veg.Class C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dem",{"$f":"SQRT(32.2)*AT11*AT13*AT14","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,9.14,0.4]
[null,"IDF Variables*",null,null,null,"Watershed Results",null,null,null,null,null,null,"Segment Summary"]
["RI","a","b","m",null,"RI","tov","tsc","tch","tc","I","Q","dn","n","V","R","n Class"]
[2,53.726799271990352,11.595132473353704,0.84527644113220524,null,2,4.4834143295346749,4.7276608712194292,5.4496976778661566,14.660772878620261,3.3927497132280111,12.403892951561611,1.3432497546527264,6.4543032183467131E-2,1.8349641743641687,0.71152017146105617,"SCS"]
[5,43.895400147179522,9.7787180770146733,0.75472248691685773]
[10,38.501360729278552,8.3018260465687419,0.69580133958464829]
[25,32.77347011672444,6.5979202194491791,0.62408538869298791,null,5,4.2152595441201814,4.7276608712194292,5.1437501522772573,14.086670567616867,4.0048489009040322,14.641727581705142,1.4263401355269487,6.3174703649419517E-2,1.9441068683269478,0.75139241676729229,"SCS"]
[50,29.200379066799563,5.3189256297173415,0.5733424915501083]
[100,26.499990062261023,4.1819186612873409,0.5284919311867059]
[null,null,null,null,null,10,4.0299956105069628,4.7276608712194292,4.9513757396565756,13.709032221382969,4.4798912482339341,16.378482403543266,1.48541475089499,6.2330537327072388E-2,2.0196407071085245,0.77971208480092769,"SCS"]
["* I = a / (tc + b) ^ m"]
[]
[null,null,null,null,null,25,3.8359335688304577,4.7276608712194292,4.7385793857125851,13.302173825762472,5.0690423522221124,18.532418839724045,1.5525947668371027,6.1281954547631204E-2,2.1103371255425754,0.8118923648544023,"SCS"]
[]
[]
[null,null,null,null,null,50,3.7050151309802142,4.7276608712194292,4.6054832111706956,13.038159213370339,5.5054917785594535,20.128077942413363,1.5989488053618726,6.0641054788427885E-2,2.1713248190211161,0.83408267583773343,"SCS"]
[]
[]
[null,null,null,null,null,100,3.5872537403291518,4.7276608712194292,5.1642008507614863,13.479115462310066,5.8104229762229211,21.242906401071,1.7525172011670738,7.1933059201185617E-2,1.936408030784754,0.90752770983483855,"Blodgett"]
[]
[]
[null,null,null,null,null,500,null,null,null,null,null,25.4914876812852]
[]
[]
[]
[null,"DESIGN STORM"]
["tc",2,5,10,25,50,100,"IDF"]
[5,4.9999999999998952,5.7499999999998472,6.3600000000002002,7.1000000000001071,7.6600000000001245,8.2100000000000009,"FHWA"]
[null,5,5.75,6.36,7.1,7.66,8.2100000000000009,"NOAA"]
[null,-1.0480505352461478E-13,-1.5276668818842154E-13,1.9984014443252818E-13,1.0746958878371515E-13,1.2434497875801753E-13,0,"Diff"]
[10,4.0021317867704029,4.6147600949372345,5.0936695624008816,5.6768152063246635,6.1072646263549846,6.5247377680830629,"FHWA"]
[null,4,4.5999999999999996,5.08,5.66,6.1,6.52,"NOAA"]
[null,2.1317867704029325E-3,1.4760094937234847E-2,1.3669562400881574E-2,1.6815206324663379E-2,7.2646263549849266E-3,4.7377680830633651E-3,"Diff"]
[15,3.3561338354915002,3.8929279640163097,4.3057054403239219,4.8165429586289967,5.1941372339462077,5.5622130114577635,"FHWA"]
[null,3.35,3.88,4.28,4.78,5.14,5.49,"NOAA"]
[null,6.1338354915001503E-3,1.2927964016309801E-2,2.5705440323921636E-2,3.654295862899648E-2,5.4137233946208063E-2,7.2213011457763265E-2,"Diff"]
[30,2.2996009331800309,2.7234950797388229,3.0469816872219631,3.4657092768050961,3.7831191644598254,4.098705083054405,"FHWA"]
[null,2.31,2.76,3.1,3.54,3.87,4.21,"NOAA"]
[null,-1.039906681996916E-2,-3.650492026117691E-2,-5.3018312778037036E-2,-7.4290723194903929E-2,-8.6880835540174672E-2,-0.11129491694559501,"Diff"]
[60,1.4531205598929571,1.7820497110626987,2.0373967865637557,2.38521355477386,2.65919072894394,2.9379383956475102,"FHWA"]
[null,1.45,1.77,2.02,2.36,2.63,2.9,"NOAA"]
[null,3.1205598929571199E-3,1.2049711062698698E-2,1.7396786563755651E-2,2.5213554773860114E-2,2.9190728943940147E-2,3.7938395647510337E-2,"Diff"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L87-L86","v":0}]

{"sheet":"Coeff","index":2,"n_rows":95,"n_cols":42,"rows_kept":95,"cut":false,"hidden":false,"merged":[[30,16,30,25],[0,16,0,20],[0,0,0,6],[5,0,5,6],[3,16,3,17],[10,0,10,6],[40,0,40,6],[15,0,15,6],[20,0,20,6],[25,0,25,6],[30,0,30,6],[35,0,35,6],[78,41,79,41],[78,36,79,36],[78,37,79,37],[78,38,79,38],[78,39,79,39],[57,18,57,23],[62,18,62,23],[69,18,69,23],[74,18,74,23],[78,40,79,40],[88,34,89,34],[90,34,91,34],[92,34,93,34],[80,34,81,34],[82,34,83,34],[84,34,85,34],[86,34,87,34]]}
["Cairo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment Summary"]
["Return",2,5,10,25,50,100,null,null,null,null,null,null,null,null,null,"dn","n","V","R","n Class"]
["A0",6.41,8.25,9.4499999999999993,10.95,12.07,13.17]
["A1",-0.02,-3.5000000000000003E-2,-0.04,-4.2999999999999997E-2,-4.5999999999999999E-2,-4.7E-2,null,null,null,null,null,null,null,null,null,"Segm't Sum."]
["A2",-8.2000000000000003E-2,-7.5999999999999998E-2,-7.3999999999999996E-2,-7.1999999999999995E-2,-7.0000000000000007E-2,-7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"dn","n"]
["Cincinnati"]
["Return",2,5,10,25,50,100]
["A0",7.26,7.98,8.5299999999999994,9.26,9.81,10.37]
["A1",-0.127,-0.04,0,3.7999999999999999E-2,0.06,7.9000000000000001E-2]
["A2",-7.3999999999999996E-2,-8.4000000000000005E-2,-8.7999999999999995E-2,-9.1999999999999998E-2,-9.5000000000000001E-2,-9.7000000000000003E-2]
["Evansville"]
["Return",2,5,10,25,50,100]
["A0",6.68,8.2100000000000009,9.23,10.53,11.49,12.44]
["A1",-7.1999999999999995E-2,-6.6000000000000003E-2,-6.4000000000000001E-2,-6.0999999999999999E-2,-0.06,-5.8999999999999997E-2]
["A2",-7.6999999999999999E-2,-7.3999999999999996E-2,-7.3999999999999996E-2,-7.1999999999999995E-2,-7.1999999999999995E-2,-7.0999999999999994E-2]
["Knoxville"]
["Return",2,5,10,25,50,100,null,"old means - kinematic equation used prior to the current Drainage Manual"]
["A0",5.5,5.68,5.9,6.24,6.52,6.81]
["A1",3.5999999999999997E-2,0.152,0.20399999999999999,0.254,0.28299999999999997,0.307,null,"old","to = 0.42 ( L * N ) ^ 0.8 / ( P2,24 ^ 0.5 * S ^ 0.4 )",null,null,null,null,"not iterative"]
["A2",-9.5000000000000001E-2,-0.106,-0.111,-0.11600000000000001,-0.11899999999999999,-0.122]
["Lexington",null,null,null,null,null,null,null,"current","to = 0.933 ( L * N ) ^ 0.6 / ( I ^ 0.4 * S ^ 0.3 )",null,null,null,null,"note S exponent"]
["Return",2,5,10,25,50,100]
["A0",5.7,6.44,6.96,7.64,8.14,8.66,null,null,"I = Ao * tc ^ ( A1 = A2 * ln ( tc ) )",null,null,null,null,"IDF equation"]
["A1",-4.0000000000000001E-3,5.6000000000000001E-2,8.5999999999999993E-2,0.114,0.13100000000000001,0.14499999999999999]
["A2",-8.7999999999999995E-2,-9.0999999999999998E-2,-9.2999999999999999E-2,-9.5000000000000001E-2,-9.6000000000000002E-2,-9.7000000000000003E-2]
["Louisville",null,null,null,null,null,null,null,null,"L","N","S","to","tc","I100"]
["Return",2,5,10,25,50,100,null,null,28,0.2,0.02,{"$f":"0.933*(J27*K27)^0.6/(O27^0.4*L27^0.3)","v":3.5362586724254235},3.536,{"$f":"$G$23*N27^($G$24+$G$25*LN(N27))","v":8.9095052743796312},"iterative"]
["A0",7.29,8.5299999999999994,9.3699999999999992,10.47,11.28,12.11]
["A1",-0.13500000000000001,-8.4000000000000005E-2,-5.8999999999999997E-2,-3.6999999999999998E-2,-2.5000000000000001E-2,-1.4E-2,null,"P2,24","L","N","S","to-old",null,"I100*"]
["A2",-7.0999999999999994E-2,-7.5999999999999998E-2,-7.9000000000000001E-2,-8.1000000000000003E-2,-8.2000000000000003E-2,-8.4000000000000005E-2,null,3.1,28,0.2,0.02,{"$f":"0.42*(J30*K30)^0.8/(I30^0.5*L30^0.4)","v":4.5259199344218111},null,{"$f":"$G$23*M30^($G$24+$G$25*LN(M30))","v":8.6410276947111697},"not iterative"]
["Nashville",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Summary"]
["Return",2,5,10,25,50,100,null,"* - uses Q100 Lexington Region values in IDF equation",null,null,null,null,null,null,null,"ts","tp","SF","Fx","Re","Delta","A","Liner","D50c","D50"]
["A0",7.31,9.94,11.68,13.89,15.54,17.170000000000002]
["A1",-0.104,-0.159,-0.182,-0.20499999999999999,-0.218,-0.22900000000000001,null,"PI",null,"K1","mu",null,"D50"]
["A2",-7.3999999999999996E-2,-6.3E-2,-5.8999999999999997E-2,-5.3999999999999999E-2,-5.0999999999999997E-2,-4.9000000000000002E-2,null,3.1415926540000001,null,{"$f":"IF(MIN('Design Flows'!A15,'Design Flows'!C15)<1.5,0.77,IF(MIN('Design Flows'!A15,'Design Flows'!C15)>5,1,MIN('Design Flows'!A15,'Design Flows'!C15)*0.066+0.067))","v":0.26500000000000001},0.82089999999999996,null,1]
["Parkersburg",null,null,null,null,null,null,null,null,"Ch Sl",null,null,"Z"]
["Return",2,5,10,25,50,100,null,null,{"$f":"'Design Flows'!E15","v":0.01},null,null,{"$f":"'Design Flows'!A15","v":3}]
["A0",6.32,8.08,9.25,10.72,11.82,12.91,null,"Alpha =",{"$f":"ATAN('Design Flows'!E15)","v":9.9996666866652376E-3},"rad","Theta =",{"$f":"ATAN(1/MIN('Design Flows'!A15,'Design Flows'!C15))","v":0.32175055439664219},"rad"]
["A1",-4.2000000000000003E-2,-0.04,-0.04,-3.9E-2,-3.7999999999999999E-2,-3.7999999999999999E-2,null,null,{"$f":"J38*180/$I$35","v":0.57293869760867566},"deg",null,{"$f":"M38*180/$I$35","v":18.434948820514904},"deg"]
["A2",-9.0999999999999998E-2,-8.8999999999999996E-2,-8.7999999999999995E-2,-8.6999999999999994E-2,-8.6999999999999994E-2,-8.5999999999999993E-2]
["Wytheville",null,null,null,null,null,null,null,null,{"$f":"J42*I35/180","v":0.74001960294222213},"rad","num =",{"$f":"COS(J38)","v":0.99995000374968757}]
["Return",2,5,10,25,50,100,null,"Phi =",{"$f":"IF(N35=0.5,42.2,42.4)","v":42.4},"deg","dem = ",{"$f":"(2*SIN(M38)/(N50*TAN(J41)))+SIN(J38)","v":4.4594966050981473}]
["A0",6.09,6.51,6.9,7.45,7.88,8.32,null,null,null,null,"Beta=",{"$f":"ATAN(M41/M42)","v":0.22058080107886241},"rad"]
["A1",-7.0999999999999994E-2,3.7999999999999999E-2,8.5000000000000006E-2,0.128,0.154,0.17399999999999999,null,null,null,null,null,{"$f":"M43*180/I35","v":12.638348941783347},"deg"]
["A2",-0.08,-9.1999999999999998E-2,-9.6000000000000002E-2,-0.10100000000000001,-0.104,-0.106,null,"num = ",{"$f":"K35*(1+SIN(J38+M43))*TAN(J41)","v":0.29728060747945623}]
[null,null,null,null,null,null,null,null,"tl = ",{"$f":"COS(M38)*TAN(J41)","v":0.86626689234614329}]
[null,null,null,null,null,null,null,null,"tr = ",{"$f":"SIN(M38)*COS(M43)","v":0.30856573697755679},null,"Q10","Re = ",{"$f":"SQRT(32.2*'Design Flows'!H15*'Design Flows'!E15)*N35/0.00001217","v":56827.849783889884}]
[null,null,null,null,null,null,null,null,"diff =",{"$f":"J46-J47","v":0.55770115536858644},null,null,"Fx = ",{"$f":"IF(N47<40000, 0.047,IF(N47>200000,0.15,0.047+((N47-40000)/160000)*0.103))","v":5.7832928298379112E-2}]
[null,null,null,null,null,null,null,null,"dem =",{"$f":"2*J48","v":1.1154023107371729},null,null,"ts = ",{"$f":"62.4*'Design Flows'!H15*'Design Flows'!E15","v":0.92689880455847373}]
[null,null,null,null,null,null,null,null,"Delta =",{"$f":"J45/J49","v":0.26652321285131869},null,null,"mu = ",{"$f":"N49/(N48*102.96*N35)","v":0.15566415028028477}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn = alpha * Cs ^ 0.10 *h ^ 0.528",null,null,null,"(h in FT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn per Veg Class"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h (in)",36,24,8,4,1.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cs",33,7.1,3.9,2.7,3.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn",{"$f":"0.237*T61^0.1*(T60/12)^0.528","v":0.60050933435173826},{"$f":"0.237*U61^0.1*(U60/12)^0.528","v":0.41573636894609101},{"$f":"0.237*V61^0.1*(V60/12)^0.528","v":0.21921921685548709},{"$f":"0.237*W61^0.1*(W60/12)^0.528","v":0.14654287240083319},{"$f":"0.237*X61^0.1*(X60/12)^0.528","v":9.3474759965750248E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cn (general)",null,null,null,null,null,"(Cn = 0.2 is typical)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h (ft)","Ex","VG","G","F","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,{"$f":"0.237*$T$68^0.1*$S$65^0.528","v":0.16822102643793529},{"$f":"0.237*$U$68^0.1*S65^0.528","v":0.15727318120292302},{"$f":"0.237*$V$68^0.1*S65^0.528","v":0.14199888084506929},{"$f":"0.237*$W$68^0.1*S65^0.528","v":0.12216974577718247},{"$f":"0.237*$X$68^0.1*S65^0.528","v":0.11045692699106957}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"0.237*$T$68^0.1*S66^0.528","v":0.24256275480753267},{"$f":"0.237*$U$68^0.1*S66^0.528","v":0.22677674068289022},{"$f":"0.237*$V$68^0.1*S66^0.528","v":0.20475228600554565},{"$f":"0.237*$W$68^0.1*S66^0.528","v":0.17616008365507527},{"$f":"0.237*$X$68^0.1*S66^0.528","v":0.15927103208119736}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,{"$f":"0.237*$T$68^0.1*S67^0.528","v":0.30046943551077027},{"$f":"0.237*$U$68^0.1*S67^0.528","v":0.28091484743413014},{"$f":"0.237*$V$68^0.1*S67^0.528","v":0.25363252426961452},{"$f":"0.237*$W$68^0.1*S67^0.528","v":0.21821454385018718},{"$f":"0.237*$X$68^0.1*S67^0.528","v":0.19729359167539026}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cs",49,25,9,2,0.73]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cf (general)",null,null,null,null,null,null,null,"n = 0.213 * Cn * bo ^ -0.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth","Ex","VG","G","F","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sod",0.98,0.95,0.9,0.84,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bunch",0.55000000000000004,0.53,0.5,0.47,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",0.82,0.79,0.75,0.7,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cf per veg class (interpolated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e","PI","p,soil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth","A","B","C","D","E",null,null,null,null,null,null,null,null,null,null,null,null,0.5,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sod","> 0.55","> 0.98",{"$f":"T72","v":0.98},{"$f":"(W62-V65)/(U65-V65)*(U72-V72)+V72","v":0.91487463075003461},"< 0.75"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bunch","> 0.55","> 0.55",{"$f":"($V$62-V66)/(U66-V66)*(U73-V73)+V73","v":0.51970572855747865},"< 0.41","< 0.41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed","> 0.55","> 0.98",{"$f":"(V62-W67)/(V67-W67)*(V74-W74)+W74","v":0.70141830927879334},"< 0.62","< 0.62",null,null,null,null,null,null,null,null,null,null,"ASTM Soil ","Applicable ","C1 ","C2 ","C3 ","C4 ","C5 ","C6 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classification","Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GM ","10 < PI < 20",1.07,14.3,47.7,1.42,-0.61,1E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.42,-0.61,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GC ","10 < PI < 20",4.7699999999999999E-2,2.86,42.9,1.42,-0.61,1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",4.7699999999999999E-2,2.86,0.11899999999999999,1.42,-0.61,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM ","10 < PI < 20",1.07,7.15,11.9,1.42,-0.61,1E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",1.07,7.15,5.8000000000000003E-2,1.42,-0.61,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC ","10 < PI < 20",1.07,14.3,47.7,1.42,-0.61,1E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.42,-0.61,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ML ","10 < PI < 20",1.07,7.15,11.9,1.48,-0.56999999999999995,1E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",1.07,7.15,5.8000000000000003E-2,1.48,-0.56999999999999995,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL ","10 < PI < 20",1.07,14.3,47.7,1.48,-0.56999999999999995,1E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",1.07,14.3,7.5999999999999998E-2,1.48,-0.56999999999999995,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MH ","10 < PI < 20",4.7699999999999999E-2,1.43,10.7,1.38,-0.373,1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 < PI ",4.7699999999999999E-2,1.43,5.8000000000000003E-2,1.38,-0.373,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH ","20 < PI ",null,null,9.7000000000000003E-2,1.38,-0.373,1]

{"sheet":"Map","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":4,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[[3,8,3,10],[4,9,4,10]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"HYCHL Input / Output"]
[null,null,null,null,null,null,null,"iterate","Output","Input"]
[null,null,null,null,null,null,"T",{"$f":"K12+H8*(K7+K8)","v":5.0282},{"$f":"K12+I8*(K7+K8)","v":5.54},"Sl",0.14000000000000001]
[null,null,null,null,null,null,"da/D50",{"$f":"H8/H9","v":0.50470000000000004},{"$f":"I8/K9","v":0.59},"lss",3]
[null,null,null,null,null,null,"da",0.50470000000000004,0.59,"rss",3]
[null,null,null,null,null,null,"D50",1,null,"D50",1]
[null,null,null,null,null,null,"A",{"$f":"H8*(K12+H8/2*(K7+K8))","v":1.7735662700000001},2.2400000000000002,"Q",9.99]
[]
[null,null,null,null,null,null,"WP",{"$f":"K12+H8*((K7^2+1)^0.5+(K8^2+1)^0.5)","v":5.1920030701739623},5.75,"BW",2]
[null,null,null,null,null,null,"V",{"$f":"K10/H10","v":5.6327187593616106},4.46]
[null,null,null,null,null,null,"Rh",{"$f":"H10/H12","v":0.34159576680307613},{"$f":"I10/I12","v":0.3895652173913044}]
[null,null,null,null,null,null,"n",{"$f":"1.486*H14^(2/3)*K6^0.5/H13","v":4.8236199178445897E-2},6.8000000000000005E-2]
[]
[]
[]
[null,null,null,null,null,null,"for da/D50 >185",null,null,"unknown"]
[null,null,null,null,null,null,"pg. 20 eq. 27 (HYCHL Manual)"]
[null,null,null,null,null,null,"n",{"$f":"0.0232*H8^(1/6)","v":2.0701105356966915E-2}]
[]
[null,null,null,null,null,null,"for da/D50 >2 and < 185",null,null,"unknown"]
[null,null,null,null,null,null,"pg. 19 eq. 26"]
[null,null,null,null,null,null,"num",{"$f":"4.657*H14^(1/6)","v":3.8936626208645917}]
[null,null,null,null,null,null,"dem",{"$f":"32.25+5.23*LOG(H14/H9)","v":29.810270270882885}]
[null,null,null,null,null,null,"n",{"$f":"H25/H26","v":0.13061480441080461}]
[]
[null,null,null,null,null,null,"for da/D50 <2",null,null,null,null,"Bathurst"]
[null,null,null,null,null,null,"pg. 20 eq. 28"]
[null,null,null,null,null,null,null,null,null,"f(FR)",{"$f":"((0.28/H34)*H32)^LOG(0.755/H34)","v":1.0871408243243774}]
[null,null,null,null,null,null,"Fr",{"$f":"H13/(32.2*H8)^0.5","v":1.3972479442461936},null,"f(REG)",{"$f":"13.434*(H6/K9)^0.492*H34^(1.025*(H6/K9)^0.118)","v":7.0739159975089185}]
[null,null,null,null,null,null,"a",{"$f":"(1.175*(K9/H6)^0.557)^H35","v":0.54818992620150342},null,"f(CG)",{"$f":"(H6/H8)^-H34","v":0.48568446530702214}]
[null,null,null,null,null,null,"b",{"$f":"H33*(H8/K9)^H35","v":0.314154957391725},null,"f(FR)*f(REG)*f(CG)",null,{"$f":"K31*K32*K33","v":3.7350800642283777}]
[null,null,null,null,null,null,"c",{"$f":"0.648*0.182^-0.134","v":0.81418939234477206},null,null,null,null,{"$f":"L34-L36","v":7.7785584018208453E-4},"diff."]
[null,null,null,null,null,null,null,null,null,"V/sqr(g*da*S)",null,{"$f":"H13/(32.2*H8*K6)^0.5","v":3.7343022083881956}]
[]
[null,null,null,null,null,null,"user",null,null,"Anderson"]
[null,null,null,null,null,null,"pg. 22 eq. 35",null,null,"user n"]
[null,null,null,null,null,null,"n",{"$f":"0.0481*K9^(1/6)","v":4.8099999999999997E-2}]

{"sheet":"NOAA Data2","index":5,"n_rows":74,"n_cols":32,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,10],[33,0,34,0],[35,0,36,0],[37,0,38,0],[39,0,40,0],[21,0,22,0],[23,0,24,0],[25,0,26,0],[27,0,28,0],[29,0,30,0],[31,0,32,0],[9,0,10,0],[11,0,12,0],[13,0,14,0],[15,0,16,0],[17,0,18,0],[19,0,20,0],[1,0,2,0],[1,1,1,10],[3,0,4,0],[5,0,6,0],[7,0,8,0],[15,18,17,18],[15,25,15,26],[16,25,16,26],[17,25,17,26],[6,18,8,18],[6,25,6,26],[7,25,7,26],[8,25,8,26],[9,18,11,18],[9,25,9,26],[10,25,10,26],[11,25,11,26],[1,29,1,31],[12,18,14,18],[12,25,12,26],[13,25,13,26],[14,25,14,26],[1,19,1,24],[2,25,2,26],[3,18,5,18],[3,25,3,26],[4,25,4,26],[5,25,5,26]]}
["PDS-based precipitation frequency estimates with 90% confidence intervals (in inches/hour)",null,null,null,null,null,null,null,null,null,null,null,"LOCATION INFORMATION:"]
["Duration","Average recurrence interval(years)",null,null,null,null,null,null,null,null,null,null,"Name: Leitchfield, Kentucky, US*",null,null,null,{"$f":"MID(M2,7,40)","v":"Leitchfield, Kentucky, US*"},null,null,"DESIGN STORM",null,null,null,null,null,null,null,null,null,"IDF Variables*"]
[null,1,2,5,10,25,50,100,200,500,1000,null,"Station Name: -",null,null,null,null,null,"tc",2,5,10,25,50,100,"IDF",null,null,"RI","a","b","m"]
["5-min",4.26,5,5.75,6.36,7.1,7.66,8.2100000000000009,8.7200000000000006,9.3699999999999992,9.86,null,"Site ID: -",null,null,null,"Lat/Long",null,5,null,null,null,null,null,null,"FHWA",null,null,2]
[null,"(3.89‑4.64)","(4.58‑5.47)","(5.26‑6.29)","(5.80‑6.94)","(6.44‑7.75)","(6.92‑8.35)","(7.38‑8.95)","(7.79‑9.54)","(8.28‑10.3)","(8.65‑10.8)",null,"Latitude: 37.5098",null,null,null,{"$f":"VALUE(MID(M5,11,9))","v":37.509799999999998},null,null,null,null,null,null,null,null,"NOAA",null,null,5]
["10-min",3.4,4,4.5999999999999996,5.08,5.66,6.1,6.52,6.91,7.41,7.76,null,"Longitude: -86.3251",null,null,null,{"$f":"VALUE(MID(M6,11,10))","v":-86.325100000000006},null,null,null,null,null,null,null,null,"Diff",null,null,10]
[null,"(3.11‑3.71)","(3.67‑4.37)","(4.21‑5.03)","(4.64‑5.54)","(5.14‑6.17)","(5.51‑6.65)","(5.86‑7.12)","(6.17‑7.57)","(6.55‑8.12)","(6.82‑8.54)",null,"Elevation: 608ft*",null,null,null,null,null,10,null,null,null,null,null,null,"FHWA",null,null,25]
["15-min",2.83,3.35,3.88,4.28,4.78,5.14,5.49,5.82,6.22,6.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,50]
[null,"(2.59‑3.09)","(3.07‑3.67)","(3.55‑4.24)","(3.91‑4.68)","(4.34‑5.22)","(4.65‑5.62)","(4.94‑6.00)","(5.19‑6.36)","(5.50‑6.82)","(5.70‑7.15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",null,null,100]
["30-min",1.94,2.31,2.76,3.1,3.54,3.87,4.21,4.53,4.95,5.26,null,null,null,null,null,null,null,15,null,null,null,null,null,null,"FHWA"]
[null,"(1.78‑2.12)","(2.12‑2.53)","(2.52‑3.01)","(2.83‑3.39)","(3.21‑3.86)","(3.50‑4.23)","(3.78‑4.59)","(4.04‑4.95)","(4.37‑5.43)","(4.62‑5.79)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA",null,null,"* I = a / (tc + b) ^ m"]
["60-min",1.21,1.45,1.77,2.02,2.36,2.63,2.9,3.17,3.55,3.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
[null,"(1.11‑1.32)","(1.33‑1.59)","(1.62‑1.93)","(1.85‑2.21)","(2.14‑2.57)","(2.37‑2.87)","(2.61‑3.16)","(2.84‑3.47)","(3.14‑3.89)","(3.37‑4.23)",null,null,null,null,null,null,null,30,null,null,null,null,null,null,"FHWA"]
["2-hr",0.73,0.874,1.07,1.22,1.43,1.59,1.76,1.94,2.1800000000000002,2.37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
[null,"(0.670‑0.794)","(0.802‑0.952)","(0.978‑1.16)","(1.12‑1.33)","(1.30‑1.55)","(1.45‑1.73)","(1.59‑1.92)","(1.74‑2.12)","(1.93‑2.39)","(2.08‑2.60)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
["3-hr",0.52900000000000003,0.63400000000000001,0.77500000000000002,0.88800000000000001,1.04,1.17,1.3,1.44,1.63,1.78,null,null,null,null,null,null,null,60,null,null,null,null,null,null,"FHWA"]
[null,"(0.489‑0.577)","(0.585‑0.692)","(0.713‑0.845)","(0.816‑0.967)","(0.955‑1.14)","(1.07‑1.28)","(1.18‑1.42)","(1.29‑1.57)","(1.44‑1.78)","(1.56‑1.96)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOAA"]
["6-hr",0.32700000000000001,0.39100000000000001,0.47799999999999998,0.55100000000000005,0.65300000000000002,0.73799999999999999,0.82699999999999996,0.92300000000000004,1.06,1.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff"]
[null,"(0.303‑0.356)","(0.362‑0.426)","(0.442‑0.520)","(0.507‑0.598)","(0.598‑0.708)","(0.671‑0.801)","(0.746‑0.899)","(0.824‑1.00)","(0.931‑1.15)","(1.02‑1.28)"]
["12-hr",0.19600000000000001,0.23400000000000001,0.28699999999999998,0.33100000000000002,0.39200000000000002,0.44400000000000001,0.498,0.55600000000000005,0.63800000000000001,0.70599999999999996]
[null,"(0.181‑0.214)","(0.217‑0.256)","(0.264‑0.313)","(0.304‑0.360)","(0.358‑0.427)","(0.401‑0.483)","(0.447‑0.543)","(0.494‑0.606)","(0.558‑0.699)","(0.609‑0.777)"]
["24-hr",0.12,0.14299999999999999,0.17499999999999999,0.20100000000000001,0.23699999999999999,0.26600000000000001,0.29699999999999999,0.32900000000000001,0.374,0.41]
[null,"(0.112‑0.129)","(0.133‑0.155)","(0.163‑0.189)","(0.186‑0.216)","(0.219‑0.255)","(0.245‑0.287)","(0.272‑0.320)","(0.300‑0.354)","(0.338‑0.403)","(0.368‑0.443)"]
["2-day",7.1999999999999995E-2,8.5999999999999993E-2,0.105,0.121,0.14399999999999999,0.16200000000000001,0.182,0.20300000000000001,0.23200000000000001,0.25600000000000001]
[null,"(0.066‑0.078)","(0.079‑0.093)","(0.097‑0.114)","(0.112‑0.131)","(0.132‑0.156)","(0.149‑0.176)","(0.166‑0.197)","(0.184‑0.219)","(0.208‑0.252)","(0.228‑0.278)"]
["3-day",5.0999999999999997E-2,6.0999999999999999E-2,7.4999999999999997E-2,8.5999999999999993E-2,0.10100000000000001,0.114,0.127,0.14099999999999999,0.161,0.17599999999999999]
[null,"(0.047‑0.055)","(0.057‑0.066)","(0.069‑0.081)","(0.079‑0.093)","(0.093‑0.110)","(0.105‑0.124)","(0.116‑0.138)","(0.128‑0.153)","(0.145‑0.174)","(0.157‑0.192)"]
["4-day",4.1000000000000002E-2,4.9000000000000002E-2,5.8999999999999997E-2,6.8000000000000005E-2,0.08,0.09,0.1,0.11,0.125,0.13700000000000001]
[null,"(0.038‑0.044)","(0.045‑0.053)","(0.055‑0.065)","(0.063‑0.074)","(0.074‑0.087)","(0.083‑0.097)","(0.091‑0.108)","(0.100‑0.120)","(0.113‑0.136)","(0.122‑0.149)"]
["7-day",2.8000000000000001E-2,3.3000000000000002E-2,4.1000000000000002E-2,4.7E-2,5.5E-2,6.2E-2,7.0000000000000007E-2,7.8E-2,8.8999999999999996E-2,9.8000000000000004E-2]
[null,"(0.026‑0.030)","(0.031‑0.036)","(0.037‑0.044)","(0.043‑0.051)","(0.051‑0.060)","(0.057‑0.068)","(0.063‑0.076)","(0.070‑0.084)","(0.079‑0.097)","(0.087‑0.107)"]
["10-day",2.1999999999999999E-2,2.5999999999999999E-2,3.2000000000000001E-2,3.5999999999999997E-2,4.2000000000000003E-2,4.7E-2,5.1999999999999998E-2,5.8000000000000003E-2,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"(0.021‑0.024)","(0.024‑0.029)","(0.030‑0.035)","(0.034‑0.039)","(0.039‑0.046)","(0.043‑0.051)","(0.048‑0.057)","(0.052‑0.062)","(0.058‑0.070)","(0.063‑0.077)"]
["20-day",1.4999999999999999E-2,1.7999999999999999E-2,2.1000000000000001E-2,2.4E-2,2.7E-2,0.03,3.2000000000000001E-2,3.5000000000000003E-2,3.7999999999999999E-2,0.04]
[null,"(0.014‑0.016)","(0.017‑0.019)","(0.020‑0.023)","(0.022‑0.025)","(0.025‑0.029)","(0.028‑0.032)","(0.030‑0.034)","(0.032‑0.037)","(0.035‑0.040)","(0.037‑0.043)"]
["30-day",1.2E-2,1.4999999999999999E-2,1.7000000000000001E-2,1.9E-2,2.1000000000000001E-2,2.3E-2,2.5000000000000001E-2,2.7E-2,0.03,3.1E-2]
[null,"(0.012‑0.013)","(0.014‑0.015)","(0.016‑0.018)","(0.018‑0.020)","(0.020‑0.023)","(0.022‑0.025)","(0.024‑0.027)","(0.025‑0.029)","(0.027‑0.032)","(0.029‑0.034)"]
["45-day",0.01,1.2E-2,1.4E-2,1.4999999999999999E-2,1.7000000000000001E-2,1.9E-2,0.02,2.1000000000000001E-2,2.3E-2,2.4E-2]
[null,"(0.010‑0.011)","(0.011‑0.013)","(0.013‑0.015)","(0.015‑0.016)","(0.016‑0.018)","(0.018‑0.020)","(0.019‑0.021)","(0.020‑0.022)","(0.021‑0.024)","(0.022‑0.026)"]
["60-day",8.9999999999999993E-3,1.0999999999999999E-2,1.2E-2,1.4E-2,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2,1.7999999999999999E-2,1.9E-2,0.02]
[null,"(0.009‑0.010)","(0.010‑0.011)","(0.012‑0.013)","(0.013‑0.014)","(0.014‑0.016)","(0.015‑0.017)","(0.016‑0.018)","(0.017‑0.019)","(0.018‑0.020)","(0.019‑0.021)"]
[]
[null,1]
["NOAA intensity",null,2,5,10,25,50,100,200,500,1000]
["5-min",{"$f":"B4","v":4.26},5,5.75,6.36,7.1,7.66,8.2100000000000009,8.7200000000000006,9.3699999999999992,{"$f":"K4","v":9.86}]
["10-min",{"$f":"B6","v":3.4},4,4.5999999999999996,5.08,5.66,6.1,6.52,6.91,7.41,{"$f":"K6","v":7.76}]
["15-min",{"$f":"B8","v":2.83},3.35,3.88,4.28,4.78,5.14,5.49,5.82,6.22,{"$f":"K8","v":6.5}]
["30-min",{"$f":"B10","v":1.94},2.31,2.76,3.1,3.54,3.87,4.21,4.53,4.95,{"$f":"K10","v":5.26}]
["60-min",{"$f":"B12","v":1.21},1.45,1.77,2.02,2.36,2.63,2.9,3.17,3.55,{"$f":"K12","v":3.84}]
["2-hr",{"$f":"B14","v":0.73},0.874,1.07,1.22,1.43,1.59,1.76,1.94,2.1800000000000002,{"$f":"K14","v":2.37}]
[]
["NOAA Depth"]
["5-min",0.35399999999999998,0.41599999999999998,0.47699999999999998,0.52700000000000002,0.58699999999999997,0.63300000000000001,0.67700000000000005,0.71899999999999997,0.77,0.80900000000000005]
["10-min",0.56499999999999995,0.66500000000000004,0.76300000000000001,0.84199999999999997,0.93600000000000005,1.01,1.08,1.1399999999999999,1.22,1.27]
["15-min",0.70699999999999996,0.83499999999999996,0.96599999999999997,1.07,1.19,1.28,1.36,1.44,1.53,1.6]
["30-min",0.96899999999999997,1.1499999999999999,1.37,1.54,1.76,1.92,2.08,2.2400000000000002,2.44,2.59]
["60-min",1.21,1.45,1.76,2.0099999999999998,2.34,2.6,2.87,3.14,3.5,3.78]
["2-hr",1.45,1.73,2.1,2.39,2.8,3.12,3.45,3.79,4.25,4.6100000000000003]
[]
["calc intensity"]
["5-min",{"$f":"B53/5*60","v":4.2480000000000002},{"$f":"C53/5*60","v":4.992},5.7240000000000002,6.3240000000000007,7.0439999999999996,7.5959999999999992,8.1240000000000006,8.6279999999999983,9.24,9.7080000000000002]
["10-min",{"$f":"B54/10*60","v":3.3899999999999997},{"$f":"C54/10*60","v":3.99},4.5780000000000003,5.0519999999999996,5.6160000000000005,6.0600000000000005,6.48,6.84,7.32,7.62]
["15-min",{"$f":"B55/15*60","v":2.8279999999999998},{"$f":"C55/15*60","v":3.34},3.8639999999999999,4.28,4.76,5.12,5.44,5.76,6.12,6.4]
["30-min",{"$f":"B56/30*60","v":1.9380000000000002},{"$f":"C56/30*60","v":2.2999999999999998},2.74,3.08,3.52,3.84,4.16,4.4800000000000004,4.88,5.18]
["60-min",{"$f":"B57","v":1.21},{"$f":"C12","v":1.45},1.77,2.02,2.36,2.63,2.9,3.17,3.55,{"$f":"K12","v":3.84}]
["2-hr",{"$f":"B58/120*60","v":0.72499999999999998},{"$f":"C58/120*60","v":0.86499999999999999},1.05,1.1950000000000001,1.4,1.56,1.7250000000000001,1.8949999999999998,2.125,2.3050000000000002]
[]
["NOAA-calc"]
["5-min",{"$f":"B45-B61","v":1.1999999999999567E-2},{"$f":"C45-C61","v":8.0000000000000071E-3},2.5999999999999801E-2,3.5999999999999588E-2,5.600000000000005E-2,6.4000000000000945E-2,8.6000000000000298E-2,9.2000000000002302E-2,0.12999999999999901,0.15199999999999925]
["10-min",{"$f":"B46-B62","v":1.0000000000000231E-2},9.9999999999997868E-3,2.1999999999999353E-2,2.8000000000000469E-2,4.3999999999999595E-2,3.9999999999999147E-2,3.9999999999999147E-2,7.0000000000000284E-2,8.9999999999999858E-2,0.13999999999999968]
["15-min",{"$f":"B47-B63","v":2.0000000000002238E-3},1.0000000000000231E-2,1.6000000000000014E-2,0,2.0000000000000462E-2,1.9999999999999574E-2,4.9999999999999822E-2,6.0000000000000497E-2,9.9999999999999645E-2,9.9999999999999645E-2]
["30-min",{"$f":"B48-B64","v":1.9999999999997797E-3},1.0000000000000231E-2,1.9999999999999574E-2,2.0000000000000018E-2,2.0000000000000018E-2,3.0000000000000249E-2,4.9999999999999822E-2,4.9999999999999822E-2,7.0000000000000284E-2,8.0000000000000071E-2]
["60-min",{"$f":"B49-B65","v":0},0,0,0,0,0,0,0,0,0]
["2-hr",{"$f":"B50-B66","v":5.0000000000000044E-3},9.000000000000008E-3,2.0000000000000018E-2,2.4999999999999911E-2,3.0000000000000027E-2,3.0000000000000027E-2,3.499999999999992E-2,4.5000000000000151E-2,5.500000000000016E-2,6.4999999999999947E-2]